Service Station / Fuel Retail Model - 3-Year P&L, FCFE Valuation & KPI Dashboard – Excel XLSX

The Service Station / Fuel Retail Model captures how a forecourt actually makes money: fuel sold by volume at a cents-per-litre margin, and a convenience shop earning a gross-profit rate on its own sales, sitting on top of a shared operating-cost base. It is built for operators, buyers and lenders assessing a single site.

What the model does: it builds a three-year profit and loss, with Year 1 modelled month by month so seasonality is visible, then rolls into annual Years 2 and 3. Fuel gross profit is driven by litres × cents-per-litre, kept deliberately separate from shop gross profit (sales × GP%), because the two behave differently and blending them hides the story. Below the gross line sit staff, rent, utilities and the other running costs. The model then capitalises free cash flow to equity into an indicative business valuation, and surfaces the KPIs a forecourt is judged on.

Main features: fuel volume and cpl margin build; shop GP modelled independently; a 3-year P&L with a monthly Year 1; an FCFE capitalisation valuation; a KPI dashboard including breakeven litres per month; and two two-way sensitivity grids on the indicative business value, covering the drivers that matter most – fuel margin (±3 cpl) against shop GP% (±5 points), and fuel margin against fuel volume (±20%). Each grid re-derives Year 1 free cash flow with operating costs held fixed, and a check cell confirms its centre equals the base value. 560 live formulas, recalc-verified with zero formula errors.

How to work with it: change only the blue input cells; yellow-filled input cells are the key drivers. Fuel volumes are in litres and margins in cents per litre – relabel units if your market differs. A worked example is preloaded so you can see the mechanics before entering your own site.

Why you need it: petrol-station economics are specific, and a generic P&L template won't separate fuel from shop or value the business properly. This one is fully unlocked, every formula visible, with a plain-English guide and honest notes on the cover. Currency-agnostic; treat $ as your currency. For analysis only, not investment advice.